How to Create a Reporting Unit Rollup

When you click Create a Reporting Unit Rollup in Reporting Unit Rollups, you must complete two steps to create a rollup: In step 1, you define its properties; and, in step 2, you map the reporting units to the entities under which they should roll up in master trial balances.

Defining the Properties of the Rollup

In step 1 of Create a Reporting Unit Rollup, do the following:

  1. Enter a unique name for the rollup.
  2. Select the ONESOURCE application that will provide a list of entities to which you will map reporting units. When you do so, the year of the most recent master chart of accounts that is available in the ONESOURCE application that you selected is displayed by default in the following field as the year of the rollup.
  3. Either accept the default year that is displayed as the year of the rollup, or select a different year. The only years available for selection will be those for which a master chart of accounts exists in the ONESOURCE application you selected to provide entities.
  4. Click Next to go to step 2 to do the mapping.

Note: The lists of entities are delivered to General Ledger Manager from ONESOURCE Income Tax and ONESOURCE Tax Provision by web service.

Mapping Reporting Units to Entities

In step 2 of Create a Reporting Unit Rollup, do the following:

  1. Select a reporting unit code in the Reporting Units pane on the left and drag it to the appropriate entity in the Entities pane on the right under which you want it to roll up in the creation of a master trial balance. Reporting units can be mapped to multiple entities in a reporting unit rollup as long as the allocation of a reporting unit doesn't exceed 100% when the rollup is saved. When you point your cursor to a mapped reporting unit in the Reporting Units pane, a tooltip displays the name of the entity or entities to which it is mapped. Entity codes in the tooltip are links that you can click to filter the Entities pane by that code.

    When you map a reporting unit to an entity, the entity in the Entities pane automatically expands, if collapsed, and reveals the reporting units that have been mapped to it. At the same time, the record of the reporting unit you mapped becomes gray in the Reporting Units pane. By default a reporting unit mapped to an entity is allocated to that entity by 100%. The Allocation% column of the Reporting Units pane indicates the number of entities to which a reporting unit is mapped and their total percentage. An Allocation % also appears in the Entities pane for each reporting unit mapping. If you've mapped a reporting unit to multiple entities, the next step is to edit the percentage of the reporting unit that should be allocated to each entity.
  2. Edit the percentages of allocation for reporting units mapped to multiple entities. Each reporting unit must be allocated at 100%. Negative numbers and up to two decimal places can be used. No reporting unit rollup can be saved until the total overall allocation of each mapped reporting unit is equal to 100%.
  3. Click Save to save the reporting unit rollup and to return to the List View where the new rollup should appear in the list.

Note: All of the reporting units entered in Reporting Units are available to you for mapping to entities. If you do not see a reporting unit in the Reporting Units pane that should be there, then go to Reporting Units to create it. Once you create it in Reporting Units, it will display in the Reporting Units pane when you return to your reporting unit rollup using Edit a Reporting Unit Rollup.

How to Remove Mapping

If you need to remove the mapping of a reporting unit to an entity as you create a reporting unit rollup, do the following:

  1. Expand the entity to which the reporting unit is currently mapped to reveal all of the reporting units mapped to it. If you do not know where it is mapped, then point your cursor at the grayed out, reporting unit in the Reporting Units pane on the left. A tooltip displays the entity to which it is mapped.
  2. In the expanded entity, point your cursor at the reporting unit that you want to remove. A red x will display next to the reporting unit.
  3. Click the red x to remove the reporting unit from the entity. The reporting unit will no longer appear beneath the entity, and will no longer appear as grayed out in the Reporting Units pane, indicating that it is available for mapping to another entity.